FaStudentLoanPeriod

Logical Entity Name | FaStudentLoanPeriod
Default Table Name | FaStudentLoanPeriod
Physical Only | NO
Owner | dbo
Definition |
Note |

FaStudentLoanPeriod Columns

ColumnName | Domain | Datatype | NULL | Definition
FaStudentLoanPeriodID |  | int | NO |
AdEnrollID |  | int | NO |
Sequence |  | int | NO |
StartDate |  | datetime | NO |
EndDate |  | datetime | NO |
AwardYear1 |  | varchar(7) | NO |
AwardYear2 |  | varchar(7) | YES |
PackageDate |  | datetime | YES |
WeeksInLP |  | numeric(4, 1) | YES |
MonthsInLP |  | numeric(4, 1) | YES |
WeeksNonEnroll |  | numeric(4, 1) | YES |
WeeksEnrolledInLP |  | numeric(4, 1) | YES |
CreditHoursInLP |  | numeric(7, 2) | NO |
CreditHoursExpToComplete |  | numeric(7, 2) | YES |
CostOfAttend |  | money | YES |
InstitutionalCharges |  | money | YES |
Tuition |  | money | YES |
BooksSupplies |  | money | YES |
RoomBoard |  | money | YES |
Travel |  | money | YES |
BankFees |  | money | NO |
OtherDescrip1 |  | varchar(40) | YES |
OtherAmount1 |  | money | YES |
OtherInst1 |  | bit | NO |
OtherDescrip2 |  | varchar(40) | YES |
OtherAmount2 |  | money | YES |
OtherInst2 |  | bit | NO |
OtherDescrip3 |  | varchar(40) | YES |
OtherAmount3 |  | money | YES |
OtherInst3 |  | bit | NO |
OtherDescrip4 |  | varchar(40) | YES |
OtherAmount4 |  | money | YES |
OtherInst4 |  | bit | NO |
OtherDescrip5 |  | varchar(40) | YES |
OtherAmount5 |  | money | YES |
OtherInst5 |  | bit | NO |
OtherDescrip6 |  | varchar(40) | YES |
OtherAmount6 |  | money | YES |
OtherInst6 |  | bit | NO |
OtherDescrip7 |  | varchar(40) | YES |
OtherAmount7 |  | money | YES |
OtherInst7 |  | bit | NO |
OtherDescrip8 |  | varchar(40) | YES |
OtherAmount8 |  | money | YES |
OtherInst8 |  | bit | NO |
Comment |  | varchar(4000) | YES |
PackagedToAdAttStatID |  | int | YES |
unsubeligibilityuptoheal |  | bit | NO |
UnsupportedDependent |  | bit | NO |
ExcludeSummerPackaging |  | bit | NO |
HPPALevel |  | char(1) | NO |
PLUSCreditDecisionStatus |  | char(1) | YES |
ReentryLP |  | bit | NO |
ExcludeStartDateFromAutoAdjust |  | bit | NO |
ExcludeEndDateFromAutoAdjust |  | bit | NO |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
AdGradeLevelID |  | int | NO |
BBAYStartDate |  | datetime | YES |
BBAYEndDate |  | datetime | YES |
IWINLP |  | numeric(4, 1) | NO |
IWMonths |  | numeric(4, 1) | NO |
RefWeeksInLP |  | numeric(4, 1) | YES |
RefCreditHoursInLP |  | numeric(7, 2) | YES |
IsStubLoanPeriod |  | bit | NO |
ScheduledComplete |  | bit | NO |
BooksSuppliesInst |  | bit | NO |
RoomBoardInst |  | bit | NO |
TravelInst |  | bit | NO |
OtherAmount9 |  | numeric(19, 4) | YES |
OtherAmount10 |  | numeric(19, 4) | YES |
OtherAmount11 |  | numeric(19, 4) | YES |
OtherDescrip9 |  | nchar(40) | YES |
OtherDescrip10 |  | nchar(40) | YES |
OtherDescrip11 |  | nchar(40) | YES |
OtherInst9 |  | bit | NO |
OtherInst10 |  | bit | NO |
OtherInst11 |  | bit | NO |
TuitionLock |  | bit | NO |
BookSuppliesLock |  | bit | NO |
RoomBoardLock |  | bit | NO |
TravelLock |  | bit | NO |
BankFeesLock |  | bit | NO |
Other1Lock |  | bit | NO |
Other2Lock |  | bit | NO |
Other3Lock |  | bit | NO |
Other4Lock |  | bit | NO |
Other5Lock |  | bit | NO |
Other6Lock |  | bit | NO |
Other7Lock |  | bit | NO |
Other8Lock |  | bit | NO |
Other9Lock |  | bit | NO |
Other10Lock |  | bit | NO |
Other11Lock |  | bit | NO |
UseHousingAndFoodLabel |  | bit | NO |
HousingAndFoodLabel |  | nvarchar(40) | YES |
OnCampusHousingAndFoodLabel |  | nvarchar(40) | YES |
OffCampusHousingAndFoodLabel |  | nvarchar(40) | YES |
BooksSuppliesDescrip |  | nvarchar(40) | YES |
RoomBoardDescrip |  | nvarchar(40) | YES |
TravelDescrip |  | nvarchar(40) | YES |
TuitionDescrip |  | nvarchar(40) | YES |

FaStudentLoanPeriod Primary and Unique Keys

Key Name | Key Type | Keys
PK_FaStudentLoanPeriod_FaStudentLoanPeriodID | PrimaryKey | FaStudentLoanPeriodID

FaStudentLoanPeriod Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
AdEnroll | Non-Identifying | One To Zero or More | FK_FaStudentLoanPeriod_AdEnrollID_AdEnroll_AdEnrollID |  |  | AdEnrollID | NO | YES
SyStaff | Non-Identifying | One To Zero or More | FK_FaStudentLoanPeriod_UserID_SyStaff_SyStaffID |  |  | UserID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
FaStudAyDlDateReview | Non-Identifying | One To Zero or More | FK_FaStudAyDlDateReview_FastudentLoanPeriodID_FastudentLoanPeriod_FastudentLoanPeriodID |  |  |  | NO | YES
FaStudentLPPaymentPeriod | Non-Identifying | One To Zero or More | FK_FaStudentLPPaymentPeriod_FaStudentLoanPeriodID_FaStudentLoanPeriod_FaStudentLoanPeriodID |  |  |  | NO | YES

FaStudentLoanPeriod Check Constraints

Check Constraint Name | CheckConstraint

FaStudentLoanPeriod Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

FaStudentLoanPeriod Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentLoanPeriod | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaStudentLoanPeriod | NO |  |  |

FaStudentLoanPeriod Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaStudentLoanPeriod Data Movement Rules

Name | Type | Rule Text/Value